Northwind Test with Yukon

Quarterly Orders View

Owner

dbo

Creation Date

10-07-2003 10:31:36

Remarks


Columns

NameTypeLengthIsNullableCollation
CustomerIDnchar10SQL_Latin1_General_CP1_CI_AS 
CompanyNamenvarchar80SQL_Latin1_General_CP1_CI_AS 
CompanyNamesysname80SQL_Latin1_General_CP1_CI_AS 
Citynvarchar30SQL_Latin1_General_CP1_CI_AS 
Citysysname30SQL_Latin1_General_CP1_CI_AS 
Countrynvarchar30SQL_Latin1_General_CP1_CI_AS 
Countrysysname30SQL_Latin1_General_CP1_CI_AS 

View Definition

create view "Quarterly Orders" AS
SELECT DISTINCT Customers.CustomerID, Customers.CompanyName, Customers.City, Customers.Country
FROM Customers RIGHT JOIN Orders ON Customers.CustomerID = Orders.CustomerID
WHERE Orders.OrderDate BETWEEN '19970101' And '19971231'